Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_LOB_TEMPLATES

`ALL_LOB_TEMPLATES` describes the LOB subpartition templates accessible to the current user.

Related Views

- `DBA_LOB_TEMPLATES` describes all LOB subpartition templates in the database.

- `USER_LOB_TEMPLATES` describes the LOB subpartition templates owned by the current user. This view does not display the `USER_NAME` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`USER_NAME` | `VARCHAR2(30)` | `NOT NULL` | Owner of the table
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the table
`LOB_COL_NAME` | `VARCHAR2(4000)` |  | Name of the LOB column
`SUBPARTITION_NAME` | `VARCHAR2(34)` | `NOT NULL` | Name of the subpartition
`LOB_SEGMENT_NAME` | `VARCHAR2(34)` | `NOT NULL` | Name of the LOB segment
`TABLESPACE_NAME` | `VARCHAR2(30)` |  | Tablespace name of the subpartition

See Also: "DBA_LOB_TEMPLATES" "USER_LOB_TEMPLATES"